﻿#region DaAssStdItemScore
/*----------------------------------------------------------------
// 文件名：DaAssStdItemScore.cs
// 功能描述：类AssStdItemScore的数据访问层
//
// 
// 创建时间：2009-07-10 DtataAccess template . Ver 5.0.20090413
//
// 修改标识： 
// 修改描述： 
//----------------------------------------------------------------*/
using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Globalization;
using System.Text;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;

using Las.Model; 


namespace Las.Dal
{
	///可以继承更上层接口,IAssStdItemScore ,数据访问层基类DaBase，
	///DaBase中包含了DbException异常处理静态方法
    public	partial  class DaAssStdItemScore:DaBase<MoAssStdItemScore>
    {	 
		#region SQL const
		internal const string TABLE_COLUMNS=" ASIS_ID ,LEV_DCL_ID ,ASS_STD_ID ,ASS_ITEM_SCORE ,M_SCORE ,ASIS_STATUS ,JUDGE_ID ,JUDGE_NAME ,ASIS_REM ,CR_UID ,CR_TIME ,LU_UID ,LU_TIME ,CLASS1 ,CLASS2   ";
		
		internal const string SQL_INSERT="INSERT INTO LA_ASS_STD_ITEM_SCORE ("+TABLE_COLUMNS+") VALUES (@AsisId,@LevDclId,@AssStdId,@AssItemScore,@MScore,@AsisStatus,@JudgeId,@JudgeName,@AsisRem,@CrUid,@CrTime,@LuUid,@LuTime,@Class1,@Class2)";
		internal const string SQL_SELECT="SELECT "+TABLE_COLUMNS+" FROM LA_ASS_STD_ITEM_SCORE  ";
		internal const string SQL_SELECT_ONE=SQL_SELECT+" WHERE ASIS_ID=@AsisId";                              
		
		internal const string SQL_EXIST="SELECT COUNT(*) FROM LA_ASS_STD_ITEM_SCORE  WHERE ASIS_ID=@AsisId  ";
		internal const string SQL_UPDATE="UPDATE LA_ASS_STD_ITEM_SCORE SET LEV_DCL_ID=@LevDclId, ASS_STD_ID=@AssStdId, ASS_ITEM_SCORE=@AssItemScore, M_SCORE=@MScore, ASIS_STATUS=@AsisStatus, JUDGE_ID=@JudgeId, JUDGE_NAME=@JudgeName, ASIS_REM=@AsisRem, CR_UID=@CrUid, CR_TIME=@CrTime, LU_UID=@LuUid, LU_TIME=@LuTime, CLASS1=@Class1, CLASS2=@Class2 WHERE ASIS_ID=@AsisId";
		
		internal const string SQL_DELETE_DEFAULT = "DELETE FROM LA_ASS_STD_ITEM_SCORE ";
		internal const string SQL_DELETE="DELETE FROM LA_ASS_STD_ITEM_SCORE WHERE ASIS_ID=@AsisId";
		
		internal const string SQL_COUNT="SELECT COUNT(*) FROM LA_Ass_Std_Item_Score";
		#endregion
		       
		#region Constructor
	 
		/// <summary>
        /// 默认构造函数，使用配置文件中默认的数据库配置。
        /// </summary>
		public DaAssStdItemScore ()
		{ 
			this.db=DatabaseFactory.CreateDatabase();
		}
		/// <summary>
        /// 使用指定的databaseName数据库配置。
        /// </summary>
        /// <param name="databaseName">配置文件中数据库的配置名称。</param>
		public DaAssStdItemScore (string databaseName)
		{ 
            this.db = DatabaseFactory.CreateDatabase(databaseName);
		} 
		
		public DaAssStdItemScore (Database db)
		{ 
            this.db = db;
		} 
		
		#endregion
		
		//以下是CRUD方法，每个方法都有引入外部事务的版本

		#region 构造器模块
		
        protected override MoAssStdItemScore ConstructT()
        {
            return new MoAssStdItemScore();
        }
        #endregion
		
	    
		
		#region Add模块 Helper
		
		///build the command object.It never throw exception.
		protected override  DbCommand ConstructAddCommand(Database db)
		{
			DbCommand dbCommand = db.GetSqlStringCommand(SQL_INSERT);
			 
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"AssStdId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"AssItemScore",DbType.Int32);
			db.AddInParameter(dbCommand,"MScore",DbType.Int32);
			db.AddInParameter(dbCommand,"AsisStatus",DbType.Int32);
			db.AddInParameter(dbCommand,"JudgeId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"JudgeName",DbType.String);
			db.AddInParameter(dbCommand,"AsisRem",DbType.String);
			db.AddInParameter(dbCommand,"CrUid",DbType.AnsiString);
			db.AddInParameter(dbCommand,"CrTime",DbType.DateTime);
			db.AddInParameter(dbCommand,"LuUid",DbType.AnsiString);
			db.AddInParameter(dbCommand,"LuTime",DbType.DateTime);
			db.AddInParameter(dbCommand,"Class1",DbType.AnsiString);
			db.AddInParameter(dbCommand,"Class2",DbType.AnsiString);
			return dbCommand;
		}		
		protected override DbCommand ConstructAddCommand(Database db,MoAssStdItemScore entity)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_INSERT);			 
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString,entity.AsisId);
			db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
			db.AddInParameter(dbCommand,"AssStdId",DbType.AnsiString,entity.AssStdId);
			db.AddInParameter(dbCommand,"AssItemScore",DbType.Int32,entity.AssItemScore);
			db.AddInParameter(dbCommand,"MScore",DbType.Int32,entity.MScore);
			db.AddInParameter(dbCommand,"AsisStatus",DbType.Int32,entity.AsisStatus);
			db.AddInParameter(dbCommand,"JudgeId",DbType.AnsiString,entity.JudgeId);
			db.AddInParameter(dbCommand,"JudgeName",DbType.String,entity.JudgeName);
			db.AddInParameter(dbCommand,"AsisRem",DbType.String,entity.AsisRem);
			db.AddInParameter(dbCommand,"CrUid",DbType.AnsiString,entity.CrUid);
			db.AddInParameter(dbCommand,"CrTime",DbType.DateTime,entity.CrTime);
			db.AddInParameter(dbCommand,"LuUid",DbType.AnsiString,entity.LuUid);
			db.AddInParameter(dbCommand,"LuTime",DbType.DateTime,entity.LuTime);
			db.AddInParameter(dbCommand,"Class1",DbType.AnsiString,entity.Class1);
			db.AddInParameter(dbCommand,"Class2",DbType.AnsiString,entity.Class2);
			return dbCommand;
		}
		
		protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,MoAssStdItemScore entity)
		{
			db.SetParameterValue(addCmd,"AsisId",entity.AsisId);
			db.SetParameterValue(addCmd,"LevDclId",entity.LevDclId);
			db.SetParameterValue(addCmd,"AssStdId",entity.AssStdId);
			db.SetParameterValue(addCmd,"AssItemScore",entity.AssItemScore);
			db.SetParameterValue(addCmd,"MScore",entity.MScore);
			db.SetParameterValue(addCmd,"AsisStatus",entity.AsisStatus);
			db.SetParameterValue(addCmd,"JudgeId",entity.JudgeId);
			db.SetParameterValue(addCmd,"JudgeName",entity.JudgeName);
			db.SetParameterValue(addCmd,"AsisRem",entity.AsisRem);
			db.SetParameterValue(addCmd,"CrUid",entity.CrUid);
			db.SetParameterValue(addCmd,"CrTime",entity.CrTime);
			db.SetParameterValue(addCmd,"LuUid",entity.LuUid);
			db.SetParameterValue(addCmd,"LuTime",entity.LuTime);
			db.SetParameterValue(addCmd,"Class1",entity.Class1);
			db.SetParameterValue(addCmd,"Class2",entity.Class2);
			return addCmd;
		}
		
		protected override DbCommand PopulateAddCommandParameters(Database db,DbCommand addCmd,DataRow row)
		{
			db.SetParameterValue(addCmd,"AsisId",row["AsisId"]);
			db.SetParameterValue(addCmd,"LevDclId",row["LevDclId"]);
			db.SetParameterValue(addCmd,"AssStdId",row["AssStdId"]);
			db.SetParameterValue(addCmd,"AssItemScore",row["AssItemScore"]);
			db.SetParameterValue(addCmd,"MScore",row["MScore"]);
			db.SetParameterValue(addCmd,"AsisStatus",row["AsisStatus"]);
			db.SetParameterValue(addCmd,"JudgeId",row["JudgeId"]);
			db.SetParameterValue(addCmd,"JudgeName",row["JudgeName"]);
			db.SetParameterValue(addCmd,"AsisRem",row["AsisRem"]);
			db.SetParameterValue(addCmd,"CrUid",row["CrUid"]);
			db.SetParameterValue(addCmd,"CrTime",row["CrTime"]);
			db.SetParameterValue(addCmd,"LuUid",row["LuUid"]);
			db.SetParameterValue(addCmd,"LuTime",row["LuTime"]);
			db.SetParameterValue(addCmd,"Class1",row["Class1"]);
			db.SetParameterValue(addCmd,"Class2",row["Class2"]);
			return addCmd;
		}
		
		#endregion
		    
		#region Update模块 Helper
		
		protected override DbCommand ConstructUpdateCommand(Database db)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);		    
			db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"AssStdId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"AssItemScore",DbType.Int32);
			db.AddInParameter(dbCommand,"MScore",DbType.Int32);
			db.AddInParameter(dbCommand,"AsisStatus",DbType.Int32);
			db.AddInParameter(dbCommand,"JudgeId",DbType.AnsiString);
			db.AddInParameter(dbCommand,"JudgeName",DbType.String);
			db.AddInParameter(dbCommand,"AsisRem",DbType.String);
			db.AddInParameter(dbCommand,"CrUid",DbType.AnsiString);
			db.AddInParameter(dbCommand,"CrTime",DbType.DateTime);
			db.AddInParameter(dbCommand,"LuUid",DbType.AnsiString);
			db.AddInParameter(dbCommand,"LuTime",DbType.DateTime);
			db.AddInParameter(dbCommand,"Class1",DbType.AnsiString);
			db.AddInParameter(dbCommand,"Class2",DbType.AnsiString);
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString);
			 
			return dbCommand;
		}
		protected override DbCommand ConstructUpdateCommand(Database db,MoAssStdItemScore entity)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_UPDATE);		    
			db.AddInParameter(dbCommand,"LevDclId",DbType.AnsiString,entity.LevDclId);
			db.AddInParameter(dbCommand,"AssStdId",DbType.AnsiString,entity.AssStdId);
			db.AddInParameter(dbCommand,"AssItemScore",DbType.Int32,entity.AssItemScore);
			db.AddInParameter(dbCommand,"MScore",DbType.Int32,entity.MScore);
			db.AddInParameter(dbCommand,"AsisStatus",DbType.Int32,entity.AsisStatus);
			db.AddInParameter(dbCommand,"JudgeId",DbType.AnsiString,entity.JudgeId);
			db.AddInParameter(dbCommand,"JudgeName",DbType.String,entity.JudgeName);
			db.AddInParameter(dbCommand,"AsisRem",DbType.String,entity.AsisRem);
			db.AddInParameter(dbCommand,"CrUid",DbType.AnsiString,entity.CrUid);
			db.AddInParameter(dbCommand,"CrTime",DbType.DateTime,entity.CrTime);
			db.AddInParameter(dbCommand,"LuUid",DbType.AnsiString,entity.LuUid);
			db.AddInParameter(dbCommand,"LuTime",DbType.DateTime,entity.LuTime);
			db.AddInParameter(dbCommand,"Class1",DbType.AnsiString,entity.Class1);
			db.AddInParameter(dbCommand,"Class2",DbType.AnsiString,entity.Class2);
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString,entity.AsisId);
			 
			return dbCommand;
		}
		
		protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,MoAssStdItemScore entity)
		{
			db.SetParameterValue(updateCmd,"LevDclId",entity.LevDclId);
			db.SetParameterValue(updateCmd,"AssStdId",entity.AssStdId);
			db.SetParameterValue(updateCmd,"AssItemScore",entity.AssItemScore);
			db.SetParameterValue(updateCmd,"MScore",entity.MScore);
			db.SetParameterValue(updateCmd,"AsisStatus",entity.AsisStatus);
			db.SetParameterValue(updateCmd,"JudgeId",entity.JudgeId);
			db.SetParameterValue(updateCmd,"JudgeName",entity.JudgeName);
			db.SetParameterValue(updateCmd,"AsisRem",entity.AsisRem);
			db.SetParameterValue(updateCmd,"CrUid",entity.CrUid);
			db.SetParameterValue(updateCmd,"CrTime",entity.CrTime);
			db.SetParameterValue(updateCmd,"LuUid",entity.LuUid);
			db.SetParameterValue(updateCmd,"LuTime",entity.LuTime);
			db.SetParameterValue(updateCmd,"Class1",entity.Class1);
			db.SetParameterValue(updateCmd,"Class2",entity.Class2);
			db.SetParameterValue(updateCmd,"AsisId",entity.AsisId);
			return updateCmd;
		}
		protected override DbCommand PopulateUpdateCommandParameters(Database db,DbCommand updateCmd,DataRow row)
		{
			db.SetParameterValue(updateCmd,"LevDclId",row["LevDclId"]);
			db.SetParameterValue(updateCmd,"AssStdId",row["AssStdId"]);
			db.SetParameterValue(updateCmd,"AssItemScore",row["AssItemScore"]);
			db.SetParameterValue(updateCmd,"MScore",row["MScore"]);
			db.SetParameterValue(updateCmd,"AsisStatus",row["AsisStatus"]);
			db.SetParameterValue(updateCmd,"JudgeId",row["JudgeId"]);
			db.SetParameterValue(updateCmd,"JudgeName",row["JudgeName"]);
			db.SetParameterValue(updateCmd,"AsisRem",row["AsisRem"]);
			db.SetParameterValue(updateCmd,"CrUid",row["CrUid"]);
			db.SetParameterValue(updateCmd,"CrTime",row["CrTime"]);
			db.SetParameterValue(updateCmd,"LuUid",row["LuUid"]);
			db.SetParameterValue(updateCmd,"LuTime",row["LuTime"]);
			db.SetParameterValue(updateCmd,"Class1",row["Class1"]);
			db.SetParameterValue(updateCmd,"Class2",row["Class2"]);
			db.SetParameterValue(updateCmd,"AsisId",row["AsisId"]);
			return updateCmd;
		}
		
		protected override void PrepareDataAdapterCommand(Database db,out DbCommand dbInsertCommand,
		                     out DbCommand dbUpdateCommand,out DbCommand dbDeleteCommand)
		{
			dbInsertCommand = db.GetSqlStringCommand(SQL_INSERT);
			#region set insert cmd parameters
			db.AddInParameter(dbInsertCommand, "AsisId",DbType.AnsiString, "ASIS_ID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "LevDclId",DbType.AnsiString, "LEV_DCL_ID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "AssStdId",DbType.AnsiString, "ASS_STD_ID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "AssItemScore",DbType.Int32, "ASS_ITEM_SCORE", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "MScore",DbType.Int32, "M_SCORE", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "AsisStatus",DbType.Int32, "ASIS_STATUS", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "JudgeId",DbType.AnsiString, "JUDGE_ID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "JudgeName",DbType.String, "JUDGE_NAME", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "AsisRem",DbType.String, "ASIS_REM", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "CrUid",DbType.AnsiString, "CR_UID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "CrTime",DbType.DateTime, "CR_TIME", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "LuUid",DbType.AnsiString, "LU_UID", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "LuTime",DbType.DateTime, "LU_TIME", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "Class1",DbType.AnsiString, "CLASS1", DataRowVersion.Current);
			db.AddInParameter(dbInsertCommand, "Class2",DbType.AnsiString, "CLASS2", DataRowVersion.Current);
			#endregion
			dbUpdateCommand = db.GetSqlStringCommand(SQL_UPDATE);
			#region Set update cmd value parameters
			db.AddInParameter(dbUpdateCommand, "LevDclId", DbType.AnsiString, "LEV_DCL_ID", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "AssStdId", DbType.AnsiString, "ASS_STD_ID", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "AssItemScore", DbType.Int32, "ASS_ITEM_SCORE", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "MScore", DbType.Int32, "M_SCORE", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "AsisStatus", DbType.Int32, "ASIS_STATUS", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "JudgeId", DbType.AnsiString, "JUDGE_ID", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "JudgeName", DbType.String, "JUDGE_NAME", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "AsisRem", DbType.String, "ASIS_REM", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "CrUid", DbType.AnsiString, "CR_UID", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "CrTime", DbType.DateTime, "CR_TIME", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "LuUid", DbType.AnsiString, "LU_UID", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "LuTime", DbType.DateTime, "LU_TIME", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "Class1", DbType.AnsiString, "CLASS1", DataRowVersion.Current);
			db.AddInParameter(dbUpdateCommand, "Class2", DbType.AnsiString, "CLASS2", DataRowVersion.Current);
			#endregion
			#region set update cmd pk where parameters
			db.AddInParameter(dbUpdateCommand, "AsisId", DbType.AnsiString, "ASIS_ID", DataRowVersion.Current);
			#endregion			
			dbDeleteCommand = db.GetSqlStringCommand(SQL_DELETE);
			#region set delete cmd pk where parameters
			db.AddInParameter(dbDeleteCommand, "AsisId", DbType.AnsiString, "ASIS_ID", DataRowVersion.Current);
			#endregion
		}
		#endregion	
		
		#region Delete模块 Helper		
		
		protected override DbCommand ConstructDeleteCommand(Database db)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
			 
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString);
			 
			return dbCommand;
		}		
		protected override DbCommand ConstructDeleteCommand(Database db,MoAssStdItemScore entity)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_DELETE);
			 
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString,entity.AsisId);
		 
			return dbCommand;
		}
		
		protected override DbCommand ConstructDeleteCommandForWhere(Database db, string where)
        {
            return db.GetSqlStringCommand(SQL_DELETE_DEFAULT + where);            
        }

        protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, MoAssStdItemScore entity)
        {
			db.SetParameterValue(deleteCmd,"AsisId",entity.AsisId);
			return deleteCmd;
        }

        protected override DbCommand PopulateDeleteCommandParameters(Database db, DbCommand deleteCmd, DataRow row)
        {
			db.SetParameterValue(deleteCmd,"AsisId",row["AsisId"]);
			return deleteCmd;
        }      
		
		#endregion helper
		
		#region Query模块 Helper

        protected override DbCommand ConstructQueryCommand(string condition)
        {
            return db.GetSqlStringCommand(SQL_SELECT + condition);
        }

        #endregion
		
		#region GetEntity(s)模块 Helper
        
		protected override DbCommand ConstructSelectOneCommand(Database db,MoAssStdItemScore entity)
		{
			DbCommand dbCommand=db.GetSqlStringCommand(SQL_SELECT_ONE);
			 
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString,entity.AsisId);
			return dbCommand;
		}
		
		protected override void PopulateEntityByDataReader(IDataReader reader,ref MoAssStdItemScore entity)
		{
			if (!reader.IsDBNull(0)) entity.AsisId = reader.GetString(0);
			if (!reader.IsDBNull(1)) entity.LevDclId = reader.GetString(1);
			if (!reader.IsDBNull(2)) entity.AssStdId = reader.GetString(2);
			if (!reader.IsDBNull(3)) entity.AssItemScore = reader.GetInt32(3);
			if (!reader.IsDBNull(4)) entity.MScore = reader.GetInt32(4);
			if (!reader.IsDBNull(5)) entity.AsisStatus = reader.GetInt32(5);
			if (!reader.IsDBNull(6)) entity.JudgeId = reader.GetString(6);
			if (!reader.IsDBNull(7)) entity.JudgeName = reader.GetString(7);
			if (!reader.IsDBNull(8)) entity.AsisRem = reader.GetString(8);
			if (!reader.IsDBNull(9)) entity.CrUid = reader.GetString(9);
			if (!reader.IsDBNull(10)) entity.CrTime = reader.GetDateTime(10);
			if (!reader.IsDBNull(11)) entity.LuUid = reader.GetString(11);
			if (!reader.IsDBNull(12)) entity.LuTime = reader.GetDateTime(12);
			if (!reader.IsDBNull(13)) entity.Class1 = reader.GetString(13);
			if (!reader.IsDBNull(14)) entity.Class2 = reader.GetString(14);
		}
		
		

        protected override DbCommand ConstructSelectConditionCommand(Database db, string condition)
        {
            return db.GetSqlStringCommand(SQL_SELECT + condition);
        }
		
		#endregion	
		
		#region Count模块 Helper

        protected override DbCommand ConstructCountCommand(Database db)
        {
            return db.GetSqlStringCommand(SQL_COUNT);
        }

        protected override DbCommand ConstructCountConditionCommand(Database db, string condition)
        {
            return db.GetSqlStringCommand(SQL_COUNT + condition);
        }

		#endregion
		
		#region IsExist模块 Helper

        protected override DbCommand ConstructIsExistCommand(Database db, MoAssStdItemScore entity)
        {
            DbCommand dbCommand = db.GetSqlStringCommand(SQL_EXIST);
			db.AddInParameter(dbCommand,"AsisId",DbType.AnsiString,entity.AsisId);
			return dbCommand;
        }

		#endregion

		
		
	}
}	
#endregion

